/**
 * BladeX Commercial License Agreement
 * Copyright (c) 2018-2099, https://bladex.cn. All rights reserved.
 * <p>
 * Use of this software is governed by the Commercial License Agreement
 * obtained after purchasing a license from BladeX.
 * <p>
 * 1. This software is for development use only under a valid license
 * from BladeX.
 * <p>
 * 2. Redistribution of this software's source code to any third party
 * without a commercial license is strictly prohibited.
 * <p>
 * 3. Licensees may copyright their own code but cannot use segments
 * from this software for such purposes. Copyright of this software
 * remains with BladeX.
 * <p>
 * Using this software signifies agreement to this License, and the software
 * must not be used for illegal purposes.
 * <p>
 * THIS SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY. The author is
 * not liable for any claims arising from secondary or illegal development.
 * <p>
 * Author: Chill Zhuang (bladejava@qq.com)
 */
package org.springblade.gold.controller;

import io.swagger.v3.oas.annotations.tags.Tag;
import io.swagger.v3.oas.annotations.Operation;
import io.swagger.v3.oas.annotations.Parameter;
import com.github.xiaoymin.knife4j.annotations.ApiOperationSupport;
import lombok.AllArgsConstructor;
import jakarta.validation.Valid;

import org.springblade.core.secure.BladeUser;
import org.springblade.core.secure.annotation.PreAuth;
import org.springblade.core.mp.support.Condition;
import org.springblade.core.mp.support.Query;
import org.springblade.core.tool.api.R;
import org.springblade.core.tool.utils.Func;
import org.springframework.web.bind.annotation.*;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import org.springblade.gold.pojo.entity.InfoEntity;
import org.springblade.gold.pojo.vo.InfoVO;
import org.springblade.gold.excel.InfoExcel;
import org.springblade.gold.wrapper.InfoWrapper;
import org.springblade.gold.service.IInfoService;
import org.springblade.core.boot.ctrl.BladeController;
import org.springblade.core.tool.utils.DateUtil;
import org.springblade.core.excel.util.ExcelUtil;
import org.springblade.core.tool.constant.BladeConstant;
import org.springblade.core.tool.constant.RoleConstant;
import java.util.Map;
import java.util.List;
import jakarta.servlet.http.HttpServletResponse;

import jakarta.servlet.ServletOutputStream;
import org.springblade.gold.excel.InfoImporter;
import org.springblade.system.excel.ExcelSelectorCache;
import org.springblade.system.excel.ExcelSelectorSheetWriteHandler;
import com.alibaba.excel.EasyExcel;
import com.alibaba.excel.ExcelWriter;
import com.alibaba.excel.write.metadata.WriteSheet;
import org.apache.commons.codec.Charsets;
import java.net.URLEncoder;
import java.util.ArrayList;
import org.springblade.core.tool.utils.BeanUtil;
import org.springframework.web.multipart.MultipartFile;

/**
 * 金价数据表 控制器
 *
 * @author BladeX
 * @since 2025-04-15
 */
@RestController
@AllArgsConstructor
@RequestMapping("/gold/info")
@Tag(name = "金价数据表", description = "金价数据表接口")
public class InfoController extends BladeController {

	private final IInfoService infoService;

	/**
	 * 金价数据表 详情
	 */
	@GetMapping("/detail")
	@ApiOperationSupport(order = 1)
	@Operation(summary = "详情", description  = "传入info")
	public R<InfoVO> detail(InfoEntity info) {
		InfoEntity detail = infoService.getOne(Condition.getQueryWrapper(info));
		return R.data(InfoWrapper.build().entityVO(detail));
	}
	/**
	 * 金价数据表 分页
	 */
	@GetMapping("/list")
	@ApiOperationSupport(order = 2)
	@Operation(summary = "分页", description  = "传入info")
	public R<IPage<InfoVO>> list(@Parameter(hidden = true) @RequestParam Map<String, Object> info, Query query) {
		IPage<InfoEntity> pages = infoService.page(Condition.getPage(query), Condition.getQueryWrapper(info, InfoEntity.class));
		return R.data(InfoWrapper.build().pageVO(pages));
	}

	/**
	 * 金价数据表 自定义分页
	 */
	@GetMapping("/page")
	@ApiOperationSupport(order = 3)
	@Operation(summary = "分页", description  = "传入info")
	public R<IPage<InfoVO>> page(InfoVO info, Query query) {
		IPage<InfoVO> pages = infoService.selectInfoPage(Condition.getPage(query), info);
		return R.data(pages);
	}

	/**
	 * 金价数据表 新增
	 */
	@PostMapping("/save")
	@ApiOperationSupport(order = 4)
	@Operation(summary = "新增", description  = "传入info")
	public R save(@Valid @RequestBody InfoEntity info) {
		return R.status(infoService.save(info));
	}

	/**
	 * 金价数据表 修改
	 */
	@PostMapping("/update")
	@ApiOperationSupport(order = 5)
	@Operation(summary = "修改", description  = "传入info")
	public R update(@Valid @RequestBody InfoEntity info) {
		return R.status(infoService.updateById(info));
	}

	/**
	 * 金价数据表 新增或修改
	 */
	@PostMapping("/submit")
	@ApiOperationSupport(order = 6)
	@Operation(summary = "新增或修改", description  = "传入info")
	public R submit(@Valid @RequestBody InfoEntity info) {
		return R.status(infoService.saveOrUpdate(info));
	}

	/**
	 * 金价数据表 删除
	 */
	@PostMapping("/remove")
	@ApiOperationSupport(order = 7)
	@Operation(summary = "逻辑删除", description  = "传入ids")
	public R remove(@Parameter(description = "主键集合", required = true) @RequestParam String ids) {
		return R.status(infoService.deleteLogic(Func.toLongList(ids)));
	}


	/**
	 * 导出数据
	 */
	@PreAuth(RoleConstant.HAS_ROLE_ADMIN)
	@GetMapping("/export-info")
	@ApiOperationSupport(order = 9)
	@Operation(summary = "导出数据", description  = "传入info")
	public void exportInfo(InfoVO info, Query query, BladeUser bladeUser, HttpServletResponse response) {
		ServletOutputStream outputStream = null;
		try {

            outputStream = response.getOutputStream();
            ExcelWriter excelWriter = EasyExcel.write(outputStream).build();
            WriteSheet writeSheet = EasyExcel.writerSheet("金价数据表数据表").head(InfoExcel.class).build();
            response.setContentType("application/vnd.ms-excel");
            response.setCharacterEncoding(Charsets.UTF_8.name());
            String fileName = URLEncoder.encode("金价数据表数据", Charsets.UTF_8.name());
            response.setHeader("Content-disposition", "attachment;filename=" + fileName + ".xlsx");

            int size = 1000;
            int current = 1;
            long total = 1;
            while (current <= total) {
				query.setCurrent(current);
				query.setSize(size);
				IPage<InfoVO> page = Condition.getPage(query);
                IPage<InfoVO> pages = infoService.selectInfoPage(page, info);
                total = pages.getPages();
                current = current+1;
                List<InfoVO> records = pages.getRecords();
				List<InfoExcel> recordsExcel = BeanUtil.copyProperties(records, InfoExcel.class);
				excelWriter.write(recordsExcel, writeSheet);
            }

            excelWriter.finish();
		} catch (Exception e) {
            e.printStackTrace();
        }finally {
			ExcelSelectorCache.clear();
		}
	}

/**
	 * 导出模板
	 */
	@GetMapping("/export-template")
	@ApiOperationSupport(order = 10)
	@Operation(summary = "导出模板")
	public void exportTemplate(HttpServletResponse response){
		try{
            ArrayList<InfoExcel> exportTemplate = new ArrayList<>();
            ExcelSelectorSheetWriteHandler defaultSelectorServiceHandler = new ExcelSelectorSheetWriteHandler(InfoExcel.class);
            ExcelUtil.export(response,"数据模板","金价数据表数据表",exportTemplate,defaultSelectorServiceHandler,InfoExcel.class);
		}finally{
		    ExcelSelectorCache.clear();
		}

	}

	/**
	 * 数据导入
	 */
	@PostMapping("/import-material")
	@ApiOperationSupport(order = 11)
	@Operation(summary = "数据导入")
	public R importMaterial(MultipartFile file,String ifOverWrite){
		try{
            InfoImporter infoImporter = new InfoImporter(infoService,ifOverWrite);
            ExcelUtil.save(file,infoImporter,InfoExcel.class);
            return R.data(Func.isEmpty(infoImporter.getErrorRowList())?"":infoImporter.getErrorRowList());
		}finally {
        	ExcelSelectorCache.clear();
        }

	}

}
